package com.lu.statistics.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lu.statistics.entity.MtWeddingSingers;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface MtWeddingSingersMapper extends BaseMapper<MtWeddingSingers> {
    /**
     * 按主歌手电话统计歌手数量
     * @param phone
     * @return
     */
    int querySingersCount(@Param("phone") String phone);

    /**
     * 按婚庆id查询婚庆歌手列表
     * @param weddingId
     * @return
     */
    List<MtWeddingSingers> querySingersByWeddingId(@Param("weddingId") Integer weddingId);

    /**
     * 按套餐类型查询婚庆歌手列表
     * @param choiceType
     * @return
     */
    List<MtWeddingSingers> querySingersByWeddingType(@Param("choiceType") String choiceType);
    /**
     * 按婚庆id批量删除歌手信息
     * @param weddingId
     * @return
     */
    int deleteSingersByWeddingId(@Param("weddingId") Integer weddingId);
}
